package anbook.dao;


import anbook.dto.Board;

public interface IBoardDAO {
	Board getBoard(int idx);
	int insertBoard(Board board);
	void deleteBoard(int idx);
	void updateBoard(Board board);
	
	public static final String SQL_GET_BOARD = "select * from board where b_num = ?";
	public static final String SQL_DELETE_BOARD = "delete from board where b_num = ?";
	public static final String SQL_INSERT_BOARD = "insert into board(mb_email,b_title,b_content,b_wdate,b_visible) values(?,?,?,now(),'1')";
	public static final String SQL_UPDATE_BOARD = "update board set b_title = ?, b_content = ?, b_wdate = now(), b_visible = ? where b_num = ?";
	public static final String SQL_LAST_ID = "select last_insert_id()";
}
